package com.eascs.ticket.project.dao;

import java.util.List;

import org.springframework.stereotype.Repository;

import com.eascs.ticket.common.dao.BaseDao;

@Repository
public class ProjectDao extends BaseDao {
	public List<Object[]> getValidProjectViewList() {
		return this.findObjectsList("select id,name from project where status != 'del'");
	}

	public List<Object[]> getAllProjectViewList() {
		return this.findObjectsList("select id,name,status from project where 1=1");
	}

	public List<Object[]> getValidProjects() {
		return this.findObjectsList("select id,name from project where status != 'del'");
	}

	public List<Object[]> getAllProjects() {
		return this.findObjectsList("select id,name from project");
	}

}
